package cj.web.admin.dao;

import java.util.List;

import net.paoding.rose.jade.annotation.DAO;
import net.paoding.rose.jade.annotation.SQL;
import net.paoding.rose.jade.annotation.SQLParam;
import cj.web.admin.domain.AppDevicesAndUid;

@DAO
public interface AppDevicesAndUidDAO {

	@SQL("SELECT * FROM AppDevicesAndUid WHERE devicesId=:t.devicesId #if(:t.type!=''){AND type =:t.type } ORDER BY id LIMIT :t.start,:t.length ")
    List<AppDevicesAndUid> query(@SQLParam("t") AppDevicesAndUid appDevicesAndUid);
	
	@SQL("SELECT count(*) FROM AppDevicesAndUid WHERE devicesId=:t.devicesId #if(:t.type!=''){AND type =:t.type } ")
    int querySize(@SQLParam("t") AppDevicesAndUid appDevicesAndUid);
    
}
